using System;
using System.ComponentModel;
using System.Data;
using System.Runtime.Serialization;

namespace DataAccess
{
    /// <summary>
    /// A custom serializable dataset containing ADM_FLUJOS information.
    /// </summary>
    [Serializable]
    [DesignerCategory("code")]
    public class SigPlanAccionData : DataTable
    {
        ///
        /// Constants for table and fields mapping
        ///
        public const String SIG_PLAN_ACCION_TABLE = "SIG_PLAN_ACCION";
        public const String PLN_ID_FIELD = "PLN_ID";
        public const String PND_ID_FIELD = "PND_ID";
        public const String CLS_ID_FIELD = "CLS_ID";
        public const String DEP_ID_FIELD = "DEP_ID";
        public const String DEP_ID_PADRE_FIELD = "DEP_ID_PADRE";
        public const String FUN_ID_FIELD = "FUN_ID";
        public const String PLN_ANO_FIELD = "PLN_ANO";
        public const String PLN_NOMBRE_FIELD = "PLN_NOMBRE";
        public const String PLN_CODIGO_BPIN_FIELD = "PLN_CODIGO_BPIN";
        public const String PLN_CODIGO_PRESUPUESTAL_FIELD = "PLN_CODIGO_PRESUPUESTAL";
        public const String PLN_VALOR_APROPIACION_FIELD = "PLN_VALOR_APROPIACION";
        public const String PLN_PROBLEMA_FIELD = "PLN_PROBLEMA";
        public const String PLN_OBJETIVO_FIELD = "PLN_OBJETIVO";
        public const String PLN_DESCRIPCION_FIELD = "PLN_DESCRIPCION";
        public const String PLAC_CONS_FIELD = "PLAC_CONS";
        public const String CLS_NOMBRE_FIELD = "CLS_NOMBRE";
        public const String DEP_NOMBRE_FIELD = "DEP_NOMBRE";
        public const String TOTAL_PROGRAMADO_FIELD = "TOTAL_PROGRAMADO";
        public const String PLN_FECHA_FIELD = "PLN_FECHA";
        public const String TOTAL_DISPONIBILIDAD_ACUMULADA_FIELD = "TOTAL_DISPONIBILIDAD_ACUMULADA";
        public const String PORCENTAJE_EJECUCION_REAL_FIELD = "PORCENTAJE_EJECUCION_REAL";
        public const String TOTAL_POR_EJECUTAR_FIELD = "TOTAL_POR_EJECUTAR";
        public const String TOTAL_COMPROMETIDO_FIELD = "TOTAL_COMPROMETIDO";
        public const String TOTAL_APROPIACION_SIN_CDP_FIELD = "TOTAL_APROPIACION_SIN_CDP";
        public const String PLN_ESTADO_FIELD = "PLN_ESTADO";
                
        
        
        
        

        public SigPlanAccionData()
		{
			BuildDataTables();
		}


        protected SigPlanAccionData(SerializationInfo info, StreamingContext context)
		{
			//
		}

		/// <summary>
		/// 
		/// </summary>
		private void BuildDataTables()
		{
            Columns.Add(PLN_ID_FIELD, typeof(Decimal));
            Columns.Add(PND_ID_FIELD, typeof(Decimal));
            Columns.Add(CLS_ID_FIELD, typeof(Decimal));
            Columns.Add(DEP_ID_FIELD, typeof(String));
            Columns.Add(DEP_ID_PADRE_FIELD, typeof(String));
            Columns.Add(FUN_ID_FIELD, typeof(Decimal));
            Columns.Add(PLN_ANO_FIELD, typeof(Decimal));
            Columns.Add(PLN_NOMBRE_FIELD, typeof(String));
            Columns.Add(PLN_CODIGO_BPIN_FIELD, typeof(String));
            Columns.Add(PLN_CODIGO_PRESUPUESTAL_FIELD, typeof(String));
            Columns.Add(PLN_VALOR_APROPIACION_FIELD, typeof(Decimal));
            Columns.Add(PLN_PROBLEMA_FIELD, typeof(String));
            Columns.Add(PLN_OBJETIVO_FIELD, typeof(String));
            Columns.Add(PLN_DESCRIPCION_FIELD, typeof(String));
            Columns.Add(PLAC_CONS_FIELD, typeof(String));
            Columns.Add(CLS_NOMBRE_FIELD, typeof(String));
            Columns.Add(DEP_NOMBRE_FIELD, typeof(String));
            Columns.Add(TOTAL_PROGRAMADO_FIELD, typeof(Decimal));
            Columns.Add(PLN_FECHA_FIELD, typeof(DateTime));
            Columns.Add(TOTAL_DISPONIBILIDAD_ACUMULADA_FIELD, typeof(Decimal));
            Columns.Add(PORCENTAJE_EJECUCION_REAL_FIELD, typeof(Decimal));
            Columns.Add(TOTAL_POR_EJECUTAR_FIELD, typeof(Decimal));
            Columns.Add(TOTAL_COMPROMETIDO_FIELD, typeof(Decimal));
            Columns.Add(TOTAL_APROPIACION_SIN_CDP_FIELD, typeof(Decimal));
            Columns.Add(PLN_ESTADO_FIELD, typeof(String));
            
            
            
            
            
            TableName = SIG_PLAN_ACCION_TABLE;
		}

        /// <summary>
        /// 
        /// </summary>
        /// <param name="row"></param>
        public void Add(DataRow row)
        {
            Rows.Add(row);
        }

    }
}
